HW#5 --- last modified March 02 2019 17:05:24..

Solution set.

Due date: Dec 8

Files to be submitted:
  Hw5Problems.pdf
  Grant.txt
  Object.txt

Purpose: To gain familiarity with DBMS recovery algorithms, tuning, security, and object orientation.

Specification:

Do the following problems our of R & G: 18.5, 20.4, 20.6. Submit these as Hw5Problems.pdf. In addition, I want you to submit spools of a GRANT experiment together with any scripts you use in intially setting up your tables as Grant.txt. Then I also want you to submit the script file Object.txt that you used to carry out an OO-experiment.

For the GRANT experiment work with a friend whose name you provide (along with your own name, of course) at the top of your submission. To set things up I want you to create a table Employee(fname, lname, salary, address). I leave the types of the attributes up to you. Insert some rows into this table and REVOKE FROM your friend SELECT privileges on this table. Give a spool showing your friend not being able to see the rows. Next create a view of the columns fname, lname, address of this Employee table where the first name begins with Bob. GRANT your friend SELECT privileges on this view and give another spool showing your friend trying to access this view.

For the OO-experiment, I want you to create a type address(city, state, zip). Again, I leave the exact details of the attributes up to you. Then create a table Employee(fname, lname, salary, address) and insert a couple of rows into this table. Then give an XML DTD for this address type. Create a new table Employee2(fname, lname, salary, address2) that uses an XMLType to store the address information. Insert a couple of rows into this table.

Point Breakdown